SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41640 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41640 [ RunTime:0.003450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651278,823774,951330,374551,567686,780101,145817,69517,964588,325016,685923,873569,754627,741161,851066,367524,839051,74589,491248,234059,33111,266851,700976,997684,211594,660389,539515,855782,256264,46803,430021,419998,968694,576185,586304,945790,97534,191344,131977,1030780,390742,470706,440034,931454,788682,365023,929550,707163,977575,574264,1035073,1039849,285471,122873,588143,424594,92554,465326,872053,583858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]