SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425487 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425487 [ RunTime:0.001839s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712,941270,810062,1014560,1034071,1031331,65150,394968,75775,941307,618892,1020516,882113,824796,1040598,154942,600360,689676,283495,1040299,539585,1031075,323617,996205,172140,327932,289732,316978,816191,298916,84732,585956,457724,162501,84231,733190,77251,339034,595298,32377,123419,559988,403922,53263,594526,647724,234573,492622,466113,214146,348181,111179,367801,156877,640516,79248,808835,455687,864042,47543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425487 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425487 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]