SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 83102 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 83102 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248151,437980,355240,488154,110415,67113,441753,283530,351015,62927,928468,547304,271148,920857,155868,888182,987516,259534,229512,338023,722921,16730,1012437,718532,262676,1041077,710930,211493,482488,842654,242244,382868,452618,324562,916560,826431,274135,651832,1034064,1024901,381178,707454,422650,969997,170603,302488,852622,588743,1038967,631021,837608,596701,375714,804881,387600,695986,904034,671520,416036,67965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001916s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 83102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 83102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]