SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003024s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023394 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023394 [ RunTime:0.002222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441234,876496,261822,374735,543399,425016,960284,182362,653008,17916,362691,587468,499912,755388,730655,373137,345569,973500,223759,432375,729911,627305,1002187,452412,1002738,599074,523522,133207,164675,108245,520733,787343,393449,494289,367548,138578,553224,464056,171141,783002,702835,863093,427207,662102,225764,555744,351655,542868,306236,412533,798126,234933,842228,606606,808365,94793,265893,904494,1000367,780350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001090s ]