SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105448 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105448 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (612701,381810,1009295,480887,432057,286451,418914,353505,299423,185239,152816,1007669,194231,400724,255667,567482,37554,751482,51518,975194,474809,114244,375722,663703,695552,577234,580694,761009,897279,690927,189025,1004656,132586,81470,17101,86769,74520,48088,212667,322857,833762,591375,187855,902057,683442,868921,444948,727139,522446,278706,222212,798967,1048740,830158,250125,616393,117981,629519,746894,640440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]