SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576517 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576517 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137744,117049,290908,1032558,881532,1041624,228313,772315,422852,716584,864360,181696,119139,746278,788772,335597,403530,590480,522787,993062,323091,982947,373395,584043,810338,705767,373479,916980,126997,570164,920144,749133,239255,281241,112920,84831,221301,311053,725990,259286,889775,194743,26127,79818,822243,227928,202717,836835,987086,91385,67035,802950,40566,591382,652212,428625,571918,840936,461928,446174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001778s ]