SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809314 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809314 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412817,1007548,776162,4003,317095,395377,1020304,153544,414336,941036,26324,1017405,922808,349119,136618,550963,89298,614716,51595,540452,639259,157778,182871,346841,838908,341418,150875,810668,676954,290410,74501,588683,142528,431884,125033,629118,130745,624529,775592,453413,325454,149520,855519,383369,778295,365631,602514,494660,749227,210476,307789,1006551,447623,443627,499195,248209,706021,377005,22335,451890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809314 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000677s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809314 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]