SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311616 LIMIT 1 [ RunTime:0.000897s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311616 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317849,490205,293367,650132,513283,602394,805830,585048,937006,893373,92803,744839,937638,619301,231032,985644,678424,934837,905678,512076,703399,104941,972253,749063,934006,351895,67839,555995,461074,121473,636283,939457,51776,984653,867378,286500,107563,976710,339879,467848,1017557,818846,816908,1023944,81747,858022,559296,713599,189635,218093,996694,469988,4175,450797,294709,438327,1046937,1047499,991316,1007204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.027181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311616 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311616 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004271s ]