SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004848s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802528 LIMIT 1 [ RunTime:0.003724s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802528 [ RunTime:0.003289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248870,638717,267045,171767,347101,27184,734168,297550,764955,294551,536794,799531,136294,241736,346336,587509,311695,642671,220578,170167,164729,35602,970422,104835,97931,908352,871356,97361,259123,553079,861888,238025,917247,644320,43416,413889,144537,50407,697731,433315,1020072,692846,328727,63295,942799,934403,643487,40358,390358,192634,120718,366515,973821,21186,502671,422477,325053,327287,464210,153756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001744s ]