SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 911410 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 911410 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408822,844657,1045800,219791,407771,733474,188145,453230,822178,118900,937167,824180,38785,459251,373615,981180,740283,467683,453814,735176,332222,330388,205591,860431,88165,93694,505664,389357,255768,909613,53989,1039025,803362,158716,397730,416302,1022445,888562,501291,180365,401553,18899,299235,971091,758327,220458,682925,940758,853225,49233,49520,432511,28049,762427,868276,380639,14229,471799,1035058,742405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 911410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 911410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]