SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542040 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542040 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644850,818843,395779,763031,309457,771316,812710,31457,452474,913122,579840,579010,404431,292710,704899,916607,390627,12229,348689,793210,32307,138800,253276,604551,11112,769203,6632,649379,130768,676861,340119,593987,179824,664385,504987,266237,620997,801304,957630,310208,908166,1034085,225587,67621,173833,596868,848213,945684,223675,817609,699522,991369,821192,4476,386210,74523,205416,692909,373587,860489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]