SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842196 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842196 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (363230,102168,179728,568218,911400,154274,210895,1010948,501482,300395,921897,555420,1040970,222096,16246,116374,726072,697983,106889,120218,44657,693453,279378,315948,273929,253406,558850,199242,603543,289732,839488,495040,811242,974227,835152,284578,412099,870477,878518,371242,568047,727018,110101,52393,432307,474275,62998,179705,273125,415152,877264,645091,51756,376076,999392,752561,494400,298703,945483,313082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]