SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522685 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522685 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (263812,468135,421054,630838,196913,249056,170310,1028638,759578,87652,465013,414660,573472,577846,412213,519616,909492,509546,898274,163840,363126,752709,349037,8050,531887,661231,151049,829464,62135,505481,159042,637465,817500,976241,997509,122675,706078,359078,763361,512341,958840,691681,582583,181789,672277,1227,61097,33519,552566,465498,987527,339667,586113,489147,59864,431731,679783,828476,61559,767423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522685 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522685 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]