SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585813 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585813 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166762,500197,971941,121894,551434,921411,107503,1034750,791885,828729,568274,524391,934264,731758,44342,543227,833041,519017,970330,191563,485299,159397,618396,980972,816721,299971,504595,120158,113336,720432,1019786,466278,225345,1040175,132997,393235,573808,222286,670677,821788,737486,274251,486869,832143,860471,892586,580823,656702,940421,519573,992554,67317,449127,259299,873898,153215,117310,233797,682047,576655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004613s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]