SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031508 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031508 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56070,852160,292437,605487,694511,406123,576215,635929,613546,453831,21621,947343,886836,48774,927683,883823,759595,493075,888263,445857,269775,805269,175200,300280,694854,614106,465356,169338,21677,140037,131676,927114,186330,277998,409753,370536,451663,906874,844701,641750,539754,733910,987020,24229,578062,261744,892357,979468,519312,262561,303270,811246,837447,156064,842849,977350,1026764,51429,80176,241148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]