SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 582801 LIMIT 1 [ RunTime:0.001100s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 582801 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541232,1035373,565507,208518,868361,996871,157013,1040637,319593,996477,91016,324921,134738,859458,1031326,776102,587130,762096,253116,695586,21919,930366,800088,856548,445395,264485,443564,977497,168952,153369,45841,214163,123337,677471,1005271,50970,543262,461405,372210,769578,760103,555759,856748,20550,601559,28167,396,75638,453606,746847,967494,169601,874004,570627,685069,1006387,439958,1020382,744618,341036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 582801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 582801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001777s ]