SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311929 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311929 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400145,697474,800625,487402,688046,518009,816268,195050,1041685,611196,17878,173579,790393,877855,705093,1035910,458006,685375,912550,426122,112612,463460,988295,260790,416116,154483,642477,207523,524621,90943,1041897,380602,316942,1026069,459351,559462,639144,155632,1000617,455253,733321,173957,112164,647870,770671,521787,316492,758689,73727,809967,469575,537954,211803,298171,669551,372490,307616,240696,946820,90759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]