SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002580 LIMIT 1 [ RunTime:0.000803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002580 [ RunTime:0.002323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746380,518604,250739,33283,596611,198115,757076,809232,888853,113354,54872,782604,36426,954190,104286,687625,125311,716304,159101,238861,360600,460575,319226,430025,909345,646073,625240,449463,245861,584626,576748,120444,282516,455138,553724,659627,826770,937870,31325,515705,900251,485580,1018840,335301,856533,592979,429068,725174,424348,115330,259711,618920,456295,343397,794781,784878,958939,1043695,66124,970097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]