SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458006 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458006 [ RunTime:0.003106s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63571,109075,507114,278966,161440,444961,43108,848951,676873,992800,577203,991019,719251,812269,642214,253921,690410,495067,265709,300926,230583,250500,277586,938289,775836,282151,14543,989759,77156,382801,367171,482374,1027660,923206,239228,782054,912012,240774,884286,401373,894354,143736,925318,294551,274967,1036688,198508,607384,228619,995141,712137,566735,316921,480886,17937,348639,119358,442132,715355,15495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000942s ]