SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046197 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046197 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221445,1029683,233784,671351,136943,984256,297178,502409,1038890,398714,524724,791105,901762,798754,100662,802089,838432,160564,543991,910702,473495,823178,918997,83019,393375,660604,797197,450152,893460,448946,439986,644229,894813,216954,480558,426590,796446,835451,835913,930717,352819,437547,601647,916920,707838,932946,691978,532683,28443,561019,771565,220490,1031133,159855,731047,900703,743162,500639,319067,480837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]