SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455410 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455410 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164876,772137,651860,55928,130659,219635,505482,605795,403249,18831,681905,85370,87103,376409,462246,990308,103133,115041,195908,1021081,86856,879389,897115,677678,125961,167376,546706,444137,597606,32505,818491,372119,866636,222032,572965,417884,1007391,903698,864261,672104,921278,449232,447231,493906,239317,569449,995726,783380,481211,22018,219816,528,132973,283381,616414,289047,984433,647379,568616,669646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]