SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009018 LIMIT 1 [ RunTime:0.000624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009018 [ RunTime:0.002314s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730902,906270,110356,996548,31828,99844,533320,18797,801527,531816,168592,587473,211732,237189,990937,364709,234254,318395,903609,37277,31978,1031242,769274,643462,804710,968812,267294,23164,18867,967723,507060,857830,481150,262805,148659,997779,300782,448356,778174,279939,166598,70880,1000351,376850,654289,237954,666978,114696,994585,485054,408251,579982,968014,461209,252914,929777,540399,164278,353604,1040517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001273s ]