SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421414 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421414 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9084,133440,391234,35941,933169,305187,772714,234841,518973,259824,817784,54850,849224,101647,477855,737559,308371,753207,430022,619795,1007978,614998,760386,854491,355800,661761,845125,166370,1033893,674951,662255,613536,76255,683856,802205,1008213,896365,48426,236221,441451,270498,861903,554483,526981,59371,436816,1009777,103214,803433,570088,870859,558822,600716,497725,442588,720944,153594,809349,369539,658281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]