SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200610 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200610 [ RunTime:0.002196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790812,786058,819633,576347,435682,802828,20179,940654,753835,239681,750583,783295,738180,610303,881020,223767,225823,247825,26028,232732,757014,446224,895219,66777,604194,934545,301520,27555,385347,296207,1032338,901809,83028,1016657,692568,569645,426055,273269,905495,915164,108862,613702,887627,172032,799764,108397,206425,865556,1044555,140469,940031,215284,972790,71965,829834,416352,635800,232020,971454,468466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]