SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475753 LIMIT 1 [ RunTime:0.002752s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475753 [ RunTime:0.003516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216517,996978,159136,752942,271438,709640,399306,103535,355682,647217,824550,896599,410229,616443,562998,972082,942837,508536,734470,586793,470951,799536,735588,181199,873504,321598,353489,252821,794576,623726,939419,84123,733969,681141,317260,194045,780836,779849,416064,817503,713020,996053,774488,645144,440487,734781,857253,16480,66211,604447,87905,260279,534203,591867,839431,868753,34081,752519,351209,756707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]