SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40117 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40117 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188701,549715,246714,965224,318184,454728,250115,309445,660758,239457,355120,409936,566114,644351,765769,682665,917322,780035,343445,268468,528811,790445,145928,1045818,1021298,209706,642929,706160,383235,35517,631383,695896,708092,678268,873582,126403,988643,261099,367334,422230,926483,178339,640291,43576,184784,226728,403377,681715,1044880,859600,719170,781505,650869,13905,688555,933540,40291,759089,663439,193621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001727s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]