SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349398 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349398 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171304,715443,104427,765776,109262,305338,635884,627987,956860,602215,609186,150803,593494,684989,810717,916853,651141,330356,763303,868456,723744,1035222,302344,344233,927060,54408,175475,2151,551600,406671,716069,449652,815180,387525,337204,679946,406927,860466,51033,706350,959549,279807,599206,743047,301259,992461,57513,503199,924022,947027,393307,1000106,506829,316313,17890,991546,293608,841678,126999,915740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]