SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497208 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497208 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015239,419916,431962,1045282,756055,883046,634532,495400,433376,990223,268055,325445,1025052,651358,228755,656794,187766,543234,60399,995122,294243,699526,264295,851573,149077,158267,817140,853682,445485,817367,593459,115242,40667,761716,285434,834135,855979,1002256,783836,892181,548363,76701,3010,667657,401217,858616,648623,319804,781853,987812,660270,428621,285123,969981,445748,711262,636614,743611,300919,67484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]