SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585910 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585910 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122750,871474,460050,773138,894079,570479,446557,390954,501036,343546,595559,247053,302040,1038048,895513,640945,891366,711503,784451,617717,221694,543162,576738,703868,469024,70222,800707,1023263,254619,18854,468435,264497,89734,878101,506970,319774,870093,920720,1014214,573875,151599,270086,106509,696675,469857,899956,320345,214648,908030,890169,768723,153297,749171,568140,152844,455799,274518,127340,213770,617002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]