SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268671 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268671 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599735,805141,102921,447308,842249,930974,53671,170514,481102,802246,47838,610134,313097,669933,563703,177973,278819,787237,513163,462634,629230,237477,678559,14394,510462,640386,681347,835168,201838,41809,590127,190542,825953,29739,843530,377551,321916,312461,20204,657835,392843,694543,952893,215373,35883,354463,908361,99998,276906,186595,284685,675211,450059,117010,899445,1000614,519577,995317,1025876,920170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]