SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502699 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502699 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95306,811257,1007245,876538,922543,608507,16902,311811,680786,685023,500473,441682,487079,474230,722036,980510,260486,318152,221231,331375,728251,248503,1029422,444384,778116,448129,271131,890258,253450,738738,951390,603154,903518,794560,870645,689870,752984,7991,936694,439204,362490,220271,859825,921012,618704,147639,215843,874470,905972,589559,181849,797767,684374,359379,103510,998724,126291,405338,221538,678782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]