SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414799 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414799 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768223,1044369,432779,1000820,441253,174513,824687,555984,161463,161900,38222,768241,602080,824515,389902,986888,765543,560301,308114,342559,719355,937968,376850,521734,249181,1007844,203263,145559,425480,940619,278573,96909,291167,104248,993532,86858,851648,391968,34260,638158,827339,180063,364643,595638,188998,422921,504705,1007532,536506,712516,391415,695245,696721,238865,883613,195042,579118,497595,48122,697526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414799 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414799 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002542s ]