SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565993 LIMIT 1 [ RunTime:0.000948s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565993 [ RunTime:0.003545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851761,477148,725037,312303,28096,704376,35254,336399,480303,203050,995338,619104,732910,231345,1007313,306087,188303,864220,326917,469186,900283,1032883,27177,184339,439598,635182,933097,87944,25521,205186,240298,1037082,692920,100824,990148,641681,997556,705313,1041906,774129,343101,818594,580840,92441,916788,311326,996137,386524,144330,172031,887759,220149,927073,397315,179143,122362,513553,617329,591878,354250) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]