SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010828 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010828 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229701,672348,719878,1007722,733714,125714,946416,71861,138055,329555,293409,115861,340507,4524,48325,621301,199302,539469,225000,965590,19802,267325,1018875,412300,315863,561052,906800,435072,378615,458536,307672,540888,222439,272211,743647,925468,695156,341909,749470,565408,9805,98841,610559,79592,841537,977175,90774,857109,462417,546273,653687,952350,99890,711141,377194,509628,835674,763527,532658,200012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010828 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010828 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]