SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568314 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568314 [ RunTime:0.001945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141510,342307,865138,48159,926569,414772,917543,1004067,603754,580146,735597,95013,870949,735038,570606,738588,689756,38699,717801,405373,227655,186655,184161,513575,13420,506818,561908,278568,760187,774678,239497,1001989,457875,492880,757289,811175,888204,900030,400924,356411,966818,370507,536174,574792,515732,613205,507463,1047989,69020,296339,419773,880759,471610,521812,689240,167385,214121,81495,511489,600730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]