SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034257 LIMIT 1 [ RunTime:0.000667s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034257 [ RunTime:0.003722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238819,232917,761032,929278,461819,1024125,915179,511616,868883,480399,907367,615736,629721,927307,314257,814875,393954,97718,599864,133958,433175,350806,974158,679746,273965,189622,395696,738893,586277,478281,525742,707672,911920,40989,202476,266087,209974,415193,731496,628371,950137,496779,123227,792255,746844,476231,110323,580696,764272,165054,80663,497902,371192,570030,34261,596805,817601,917358,331063,448935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001421s ]