SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801754 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801754 [ RunTime:0.007004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781948,581124,855576,608670,409619,186658,2408,589383,602351,823514,535036,1040083,619387,906797,61280,622311,196456,109682,689228,346428,475271,12486,860006,651099,977849,1008447,683851,109524,402576,1031311,765458,275617,849122,297331,400691,628782,697451,460591,657756,843213,1044847,60621,841649,639399,513256,1045117,109250,202737,162459,778778,1014005,349888,975113,288454,538066,939834,119043,1018213,668736,290692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]