SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480478 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480478 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551509,199201,166555,72472,973749,749948,266225,633756,640858,225008,900084,476404,833978,200821,663927,689846,648484,43592,991784,586849,992339,68141,425369,303014,126453,154703,162408,246824,851612,186653,1010908,121394,678539,355020,551784,1040099,728149,930203,596483,832633,808886,541174,426639,122557,345866,63983,539428,718921,821212,726952,23493,874194,690043,826709,553660,68188,313119,841611,138895,154727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]