SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150499 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150499 [ RunTime:0.001441s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367861,400358,243721,352311,560931,74679,630758,1002398,526892,586875,801910,127921,454160,789044,503416,908706,176611,864804,946381,996241,50944,330639,105869,695332,1048367,566809,670151,337710,974448,831656,687744,775181,611966,57780,988365,692841,201494,932624,355022,357819,43836,221812,844278,1010336,783489,907022,537551,536951,991577,538405,618703,923292,479328,102239,61291,188972,606272,334055,603731,207033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001874s ]