SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011071 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011071 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (648587,109029,477508,539259,321554,850314,677925,852188,767922,843423,701527,136080,211180,664176,813554,900039,156867,367093,424835,399459,366493,911907,916934,588088,996414,560114,558516,35995,502580,579022,521163,205685,102116,552278,649232,814959,323986,267720,540056,848353,46180,436432,944672,320332,456743,82901,543881,568719,134571,100382,849192,1029620,6787,557223,566432,1031540,59233,795266,973019,77047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]