SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001846s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310412 LIMIT 1 [ RunTime:0.002173s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310412 [ RunTime:0.004691s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236335,808941,810574,110036,914107,534355,704281,266842,916699,496422,1041791,154386,497282,75176,982602,142029,14202,133187,889268,458363,936719,423955,672756,724082,746057,754048,667497,14025,406089,464534,390104,873661,176084,578283,762958,1027241,29759,55674,298255,1024722,596908,549721,788754,744385,210440,566196,87706,44877,461202,10010,72888,946226,343371,522054,515444,923112,448942,505374,289095,904371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004197s ]