SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466094 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466094 [ RunTime:0.002443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437716,108465,459151,120343,1041136,794559,641553,592335,148309,289395,106630,1026672,855555,386028,515737,550342,252990,982987,798048,26512,678159,916723,721017,608006,310847,334191,172631,452855,588716,157131,954014,699111,137235,246056,588243,954597,1045447,615686,305498,19104,340440,1854,28112,90257,563625,578527,42068,558266,497756,204837,652574,254287,834510,975035,219459,914145,180834,360809,355662,247077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002514s ]