SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543813 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543813 [ RunTime:0.003362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12987,244203,382612,322123,428514,565150,349358,880157,589029,302551,841970,662423,299550,144268,1028829,537629,957005,11313,254995,647865,917482,735324,985932,516557,587994,846918,154021,203991,749627,969139,621477,95248,227914,505374,429322,6429,224933,748129,920396,584736,86613,616478,783571,668606,263862,744280,883895,563948,413309,916554,987778,773266,252838,725081,685433,357001,109044,651558,313273,469761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.016395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]