SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 395046 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 395046 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152183,301665,27262,579672,487907,1017958,938116,470843,365191,29186,576536,984060,1032727,735104,877645,433340,988492,19260,96447,321922,625625,669845,394575,689621,1043182,920103,247479,5151,335729,97626,929512,135979,975664,84948,819061,131891,821612,553131,638698,813288,409323,605664,310369,636488,855235,55970,796474,644842,279604,699572,144567,882144,636085,742319,1024055,172164,339661,966969,153063,267328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 395046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 395046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]