SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42299 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42299 [ RunTime:0.004234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (307431,599681,127210,283390,474653,438910,256090,91418,815748,914335,79495,406901,997704,341073,382883,900741,541043,439243,60394,204252,488821,1047226,965175,3237,528183,490130,892821,806340,791011,329218,611594,123865,402376,681403,120422,422488,256588,45129,729449,448626,132432,600899,276362,774881,918304,429329,259149,955459,958114,431707,919288,1021295,787127,748878,371103,460293,203867,514790,525429,508067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]