SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454092 LIMIT 1 [ RunTime:0.000544s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454092 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412087,962322,432109,103232,768915,223916,594229,229461,881949,709141,561989,333242,248916,588487,618169,38790,503712,1048773,757519,11263,758798,75674,769376,804759,630878,819485,83166,394092,1030874,471803,756535,279451,87605,491500,666474,780509,932464,35130,702999,657430,254707,478522,956396,135051,663485,767191,465209,555298,409968,110303,170911,431146,67025,260931,11302,806803,365090,948940,457033,7015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454092 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454092 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]