SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014391 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014391 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266059,255281,132833,656150,854607,967013,980037,285157,703083,816382,72441,654559,881188,776118,796235,416501,7225,636652,186039,744219,96261,1044169,531327,987160,856401,769098,247972,282681,576397,761814,1044389,648320,736874,605854,725164,853771,452665,99016,475781,699347,612008,202140,490954,738065,1026055,598975,593272,744630,491408,496325,355928,733795,328744,54745,140948,747145,681672,732337,571846,241694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000846s ]