SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 849613 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 849613 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49357,568479,206200,890684,205572,150620,586059,667091,250292,245514,137411,412554,10642,58339,222448,880761,374452,517212,30574,16499,5078,952125,841827,225855,384473,117467,586071,122617,752409,653769,678318,452943,864634,443665,975708,917311,833339,706675,367385,395107,131275,764608,414069,328183,905383,870302,898154,514842,1035559,419823,694909,492521,561919,798919,121402,459405,23837,81564,146779,25874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 849613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 849613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]