SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42469 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42469 [ RunTime:0.003148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016146,490174,512780,234423,45675,1010812,736120,530283,638398,415083,335011,154571,41026,320787,316909,580142,127338,669262,539948,154935,187448,852898,781281,752389,247760,91187,963908,129543,732955,308020,101367,557868,326024,937785,689746,538372,229538,438676,750589,462886,28718,26535,43442,879345,758638,326557,566076,1009229,579275,11996,567208,431072,243427,25543,542291,109560,766342,893520,805270,80862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001737s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]