SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242912 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242912 [ RunTime:0.004307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254214,343648,930867,37453,942009,977947,411083,846907,393880,719932,100676,433932,48333,908443,1037574,266817,814651,412263,723668,103131,1011247,868130,863973,268448,1048823,713553,201475,318431,161789,549370,195433,937863,1014188,923190,340881,389430,124805,206940,630937,602703,291996,1043866,98916,12106,943800,814785,475038,888554,560566,844640,332888,727906,358120,791072,3543,306463,822510,248718,54667,874711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]