SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001936s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465923 LIMIT 1 [ RunTime:0.001412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465923 [ RunTime:0.006267s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486937,552343,883887,349800,718182,860308,374127,1043235,630830,708588,483449,1025834,1000575,540585,918063,487744,269905,623950,130140,410199,448321,514838,573594,701489,223815,74023,943949,700807,636017,667781,389212,213372,352330,653930,819509,618053,728483,299478,672905,655277,144550,973977,495574,156293,550680,676851,879059,671783,633524,439795,909868,729140,595573,72484,131843,840832,679652,854528,295592,19091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002206s ]