SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376797 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376797 [ RunTime:0.002450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002889,389349,288161,817848,478812,959747,337624,616099,723910,266609,55273,319384,298843,261202,158007,245408,857089,678577,609433,365814,162879,935440,230165,995214,325595,321523,119198,223976,301417,940801,1003379,845201,441333,144213,100842,530886,453950,318615,166560,551372,1046854,705107,906487,972074,759312,285191,168453,483065,485234,49777,567518,653550,140272,615244,27487,1003881,281348,195047,555878,827928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]