SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591012 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591012 [ RunTime:0.001547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894810,1022924,986879,104237,26055,664712,806736,720716,116401,766421,742926,336127,904992,937757,173668,590587,961737,456885,322168,732081,659266,24624,654142,404269,800073,658503,26757,438133,1019020,547848,59660,349875,302176,1044244,95928,843668,404848,457434,760799,201257,905725,241847,221326,359873,27075,549194,35168,906645,458692,910608,165769,26281,124828,359501,734592,704424,303202,889967,915678,1002816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]