SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016647 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016647 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231713,952342,1042096,454321,435290,670097,875917,626625,34179,917498,567839,987601,324027,87753,898960,909598,866815,1034372,280228,932528,297294,309128,308198,303369,276373,29587,21882,187701,756715,548551,154680,357242,743502,819868,927437,22138,21435,307061,831019,579654,941864,332583,335488,985097,599448,709729,666902,130870,579175,909372,1011778,616089,387293,375195,225286,333112,860444,1035137,134702,865879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]