SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316096 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316096 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373936,653184,258790,949833,314003,1014477,846588,607352,495104,680089,184437,629255,846891,490969,185178,269491,611703,468984,929342,388363,320603,328969,114551,95511,748449,895670,76795,605051,843769,864762,822770,484035,391378,951932,593896,840563,982318,881333,478765,139568,120867,292751,346366,809436,363043,579696,863509,209129,831280,288641,408527,408797,927917,164478,1990,332670,623421,26102,225146,569538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]