SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391112 LIMIT 1 [ RunTime:0.000639s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391112 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628022,1042135,313998,373755,528242,994637,999362,1016815,329552,832548,492962,62784,87593,673357,181457,742384,661726,438571,130205,768128,733466,196932,684714,465122,64427,820049,271734,587425,262767,991597,370067,887224,841431,235558,771704,568696,551464,16405,439041,652503,66647,451219,596978,483032,419961,942680,480163,206666,420554,120125,335074,339034,324681,134258,100593,152967,447229,51245,836459,587593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]