SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104572 LIMIT 1 [ RunTime:0.001697s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104572 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765254,779484,602970,690780,1024883,908696,85369,8210,568095,613132,856769,61100,431937,508237,386268,101255,687007,545124,635529,332264,101323,645771,116704,1024439,481957,583477,198732,766650,955884,476763,936899,1021625,515687,136877,407158,40157,753880,885530,730539,903833,963720,757032,288329,211027,749225,848390,780201,191226,868088,127612,976383,77104,620774,325997,816257,905512,302851,403609,1045429,87323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]