SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532534 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532534 [ RunTime:0.001467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651809,680120,712200,56825,972339,376699,365595,383521,460399,33483,321154,1034765,988129,106134,792217,330890,542041,1017846,1041772,257915,729212,242535,860009,909737,134019,975458,232306,267221,237943,675005,555905,1024324,563576,289663,622724,264946,805293,474496,520069,857614,643869,794112,534144,391252,39459,1047498,857961,967927,514798,26287,876194,405861,533539,828874,569160,601893,82077,1000627,190598,1006754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]