SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029131 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029131 [ RunTime:0.001408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616812,564640,760057,967255,928968,801500,991165,790556,207086,78881,280877,986954,688228,852948,820565,702121,75303,266095,271414,981028,159053,676406,911016,804883,289062,801718,591909,490117,150893,736816,326022,265518,735181,840057,332945,399663,797163,763917,169406,258767,856110,554483,988639,560338,321775,637156,305396,116488,466367,730338,286087,961726,803984,860438,730365,710205,288485,804028,533683,672637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000930s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001936s ]