SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570172 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570172 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775987,1046984,242062,457609,739033,189071,38432,834847,543024,597715,945902,597999,97092,64612,430786,534832,771092,825432,903078,76618,1006548,513888,928528,824165,77937,778815,18780,1045638,1039136,662137,681377,428835,956171,908624,535131,966756,101019,490529,1048101,727409,200844,837225,25851,360917,517562,948802,277580,801561,312749,617455,781460,191543,883288,133420,40419,392830,729616,417002,950433,516733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]