SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033087 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033087 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125957,336110,202010,526818,561643,90248,104255,702866,566873,1036717,835830,532076,174104,995366,719747,115734,85315,780479,383163,227886,291167,365116,823898,809115,473251,948999,691357,259778,860807,7715,722219,644667,642370,625287,1039324,80091,666033,16241,440624,149987,798912,654757,822227,28738,618488,1028558,373327,751796,760632,727395,38933,746183,771193,942294,562337,680887,883980,304376,692347,383277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]