SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419545 LIMIT 1 [ RunTime:0.001196s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419545 [ RunTime:0.003175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424263,566515,326211,443219,101971,726943,827892,944549,95144,460834,267881,561870,472913,643557,591366,263439,559936,288419,152201,236545,833197,277552,276452,924909,115283,638335,349770,904029,796042,730240,428087,854220,970137,651229,590910,248282,933456,1040920,1011427,172987,253482,483243,497394,208689,604561,520232,920808,11755,514107,330419,943455,735295,120764,18723,8353,916470,612919,820345,551601,875817) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]