SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54051 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54051 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919897,398239,582383,406629,1038860,572598,796761,532730,752129,259891,430424,28017,537527,103447,1020818,227596,942155,1003008,509301,721968,1000110,184682,284590,705165,646826,415637,741527,613389,487638,5194,984369,780813,779393,158603,166274,389177,894395,821454,658017,681988,762825,938121,640135,139377,526198,45580,997020,889429,815774,1036149,312940,543456,301225,216432,360250,1043358,87190,91103,498206,563490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]