SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346770 LIMIT 1 [ RunTime:0.000515s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346770 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024299,993970,992851,611064,259475,22596,781835,685103,729998,869140,536465,580548,632519,865696,362037,290264,643650,465746,38793,943763,280517,784810,924053,939270,568076,614999,1004852,972109,272945,583864,363798,455735,1028703,625386,635686,774974,720407,791218,215667,38901,377273,500884,165972,684272,224470,573013,881794,375457,380081,962512,728396,893043,883920,270123,442533,228048,784063,1015313,531423,359528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]