SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200840 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200840 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (784414,109200,36836,12265,198526,854943,270018,282931,918808,81834,233706,976750,369517,785416,483743,341402,374655,725965,123148,527900,679521,847982,135849,226823,1047575,177559,876340,263075,739504,664340,663865,991302,886607,824585,1044868,994469,928718,146824,495101,843026,715614,492761,241020,1009274,629016,59587,1042528,495991,87506,830795,932548,453854,743462,892226,436541,620242,263,231114,1044788,86113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]