SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 673240 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 673240 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (101311,880084,745478,190932,566150,808060,781371,779037,442289,109976,389271,371321,35756,289304,343697,571341,680905,637718,236059,912458,433862,548373,486887,1030384,509673,567,41,559910,669947,834678,39889,497140,195261,368345,400400,212577,78667,462598,716695,118844,869122,518837,221408,358863,46766,145711,308116,345870,307492,806472,367175,636614,400895,759053,516306,561812,50936,716577,652629,647329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 673240 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 673240 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]