SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553839 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553839 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27951,465422,819369,238528,432250,808875,849737,960491,276698,302462,233083,192442,219482,884866,814307,128058,528547,235858,717458,153034,844760,1000407,778461,177322,142593,363865,129228,406622,355192,266687,759744,905637,247542,139156,479664,190287,354024,143261,486057,337367,591291,293371,937684,150164,174906,611897,78091,212757,635330,399242,624691,917468,395751,891333,627302,506002,152478,509861,412106,168840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]