SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4551 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4551 [ RunTime:0.003702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155081,71491,121315,883069,193599,76067,1022826,428950,77069,350159,14030,2032,505019,898386,137629,3336,362907,42644,780719,789741,1022564,339482,813174,365496,1000077,200036,484805,351414,1016177,612468,903993,539574,679462,169333,991302,644636,631330,47073,744070,995390,181046,698387,485888,355825,313119,8906,478708,434046,209944,440088,415820,674765,971141,1000872,559625,861376,378637,1030377,421607,546797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]