SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414971 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414971 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200995,288333,746875,431350,1031327,397147,9355,592472,412335,116574,263171,894573,337262,990683,4065,880010,622529,707962,317456,213376,222617,909626,378663,379578,695032,29608,796173,126879,693122,387964,765816,682718,185795,40771,1025794,1004471,424102,783583,861152,112526,853749,706567,464843,632786,610984,5930,882397,400934,954194,473499,1034871,622639,133475,443889,416833,954126,450536,859155,707064,337793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]