SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394312 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394312 [ RunTime:0.005144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427275,566930,259921,610278,855509,327941,996775,643548,355663,67196,576807,175138,147553,303838,705686,828318,310746,543241,35357,282460,367866,25340,118931,988040,483419,122114,962489,963117,969827,34021,1030975,835122,268596,743401,336086,203186,505774,791624,384903,207180,5736,770118,1027031,686743,439398,198338,326746,127668,1015847,41862,840726,786359,973524,487329,640268,537936,858554,296464,155904,95555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]