SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196803 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196803 [ RunTime:0.001923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42308,217948,537057,635562,618336,1028293,435609,289339,961588,218418,224635,141757,710193,757838,467855,131255,1013471,107579,360232,315189,968802,759419,105699,482057,47243,794459,952011,781136,1022546,344821,226826,225141,304910,625840,608444,768720,42919,297790,587149,165853,494152,512513,429685,570152,391405,448227,76899,872022,861546,453488,860145,763931,262269,469869,970405,437542,55203,689074,363975,556632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]