SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450240 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450240 [ RunTime:0.003543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674964,538235,71193,982748,110538,856660,269731,956910,634247,749619,48878,396430,762069,436094,641159,972285,186340,769200,808086,338938,438172,818914,874217,451877,8787,227105,793488,822574,767439,836496,76437,152217,473779,80866,506242,214900,158058,559775,52233,742181,371097,515596,143089,361810,452413,531453,365422,321817,212267,206816,569383,1044971,768884,842798,499742,60090,374103,491885,699352,296585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]