SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027179 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027179 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882990,634385,150678,55928,918627,185180,553955,485525,587276,981235,977561,134342,1047171,195674,434730,615181,789971,490246,528606,527072,116543,24200,732503,784297,200901,293977,921751,975279,879751,740718,795975,825496,325403,689960,396580,857101,767130,115206,845139,634312,902645,327581,421140,984014,131151,819480,370230,701561,487407,822503,220826,138957,628614,299965,648255,969996,250273,760831,325015,511844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]