SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104161 LIMIT 1 [ RunTime:0.001384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104161 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195632,794824,142990,432200,579159,1017779,458230,44367,268726,142996,113059,108579,849623,929483,297250,135800,823320,201106,359219,287263,479606,183126,459387,271691,304422,781181,153169,643735,282092,147401,651904,767218,107936,857345,986070,782679,274822,56663,385212,796333,956160,432103,123923,264279,814794,802049,110549,516336,393956,257924,478455,70130,219578,768949,1022133,1018508,603169,1013415,60485,51007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]