SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553180 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553180 [ RunTime:0.008398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007977,103342,858611,211034,645488,615262,68117,644564,856464,977756,817716,932367,731594,565605,1031632,277468,619342,610853,732483,1024274,260153,159843,853586,641375,452093,596349,459033,109186,573190,12998,400663,827625,309110,687239,583084,748831,571719,38852,609687,72239,301185,466905,880143,643994,593204,837611,757928,206069,787618,372274,97990,960569,1012928,687837,578836,909114,649836,819463,495643,968339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]