SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154104 LIMIT 1 [ RunTime:0.000558s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154104 [ RunTime:0.004678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591889,137626,18030,929606,1010170,809501,637771,58774,596240,455796,851366,390078,957784,775077,794256,1003070,250056,954203,551429,930261,103565,919934,613198,701697,898940,719128,868860,618241,753185,931858,728477,447052,481144,55239,443899,736459,548884,887215,523066,881206,163947,67019,386893,22995,961878,533938,830700,498922,315305,295752,970624,352370,111795,927268,733692,583489,138825,725312,679441,813420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000772s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005589s ]