SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 911025 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911025 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825192,447525,131506,16792,396862,805833,505499,924450,625514,534627,958000,263257,348994,796618,787612,650216,148639,803866,457819,908433,442676,315912,746484,558734,261624,895577,980972,416528,762580,326170,411581,701962,43836,290787,62045,859107,640918,391743,550898,264070,809753,231966,337200,929710,865352,281014,697348,274279,872162,868767,996030,389406,526242,1007910,919185,762278,221190,219519,291188,590051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]