SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482441 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482441 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224331,316051,159348,531476,510772,626932,476768,60665,44556,748715,828391,14606,854818,327950,772741,955019,1006029,1016407,689574,244074,510210,737539,396921,394605,36065,443633,229655,80003,683999,690625,229677,688095,514459,199377,478172,273419,582129,829500,718568,462738,992340,43413,237321,186191,348026,480920,366132,69879,308289,966539,325651,726595,830334,1017765,438036,255859,214872,793076,361579,1010114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000720s ]